﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_HOLIDAYS_DE')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_HOLIDAYS_DE
	END

GO

CREATE PROCEDURE [dbo].[PRC_TB_HOLIDAYS_DE] 
(
    @THHOLIDAY Datetime
)
AS
	DELETE FROM TB_HOLIDAYS
	WHERE TH_HOLIDAY = @THHOLIDAY

GO

GRANT EXEC ON dbo.PRC_TB_HOLIDAYS_DE TO PUBLIC

GO

